package com.qijian.system.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.qijian.common.core.domain.entity.SysUser;
import com.qijian.system.domain.Remind;
import com.qijian.system.domain.vo.RemindQuery;
import com.qijian.system.domain.vo.RemindVo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 【请填写功能名称】Mapper接口
 *
 * @author qijian
 * @date 2022-08-24
 */
public interface RemindMapper extends BaseMapper<Remind> {

    @Select("select count(0) from sys_remind WHERE create_time >= CURRENT_DATE ")
    int countCurrentDateWithDel();

    List<RemindVo> getVoById(Long id);

    List<SysUser> getUserByType(String type);

    List<SysUser> getUser(@Param(Constants.WRAPPER) Wrapper<RemindQuery> queryWrapper);

    List<RemindVo> getRemindVoList(@Param(Constants.WRAPPER) Wrapper<RemindQuery> queryWrapper);
}
